Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. Sample Values: CASH - currency CREDIT - credit card DEBIT - debit card CUST_ACCT - customer credit account with retailer EBT - electronic benefits transfer CHEQUE - personal or business cheque STORED_VALUE - gift cert. or gift card COUPON - mfg coupon VOUCHER - retailer issued debit (e.g. coinstar voucher) SEND_CHECK - paid out/refund via acct pay. TRADEIN - trade in kind/trade in debit OTHER - other debit offset tender type | TY_TND | Code | varchar(20) | Tender(AS_TND) |
TillID (FK)(PK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | Till(AS_TL) |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | TillTenderSettlementTransaction(TR_TND_STLM_TL) |
OpenBalanceAmount | The opening tender balance in the TILL for a till settlement period which is the time period bounded by two TILL settlement transactions. | MO_OPN_BLNC_AMT | Money | decimal(16,5) | |
OpenMediaUnitQuantity | The opening number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL for a till settlement period which is the time period bounded by two TILL settlement transactions. | QU_OPN_MD_UN | QuantityInteger | integer | |
CloseBalanceAmount | The closing tender balance in the TILL for a till settlement period which is the time period bounded by two TILL settlement transactions. The closing balance represents the system's total. | MO_CL_BLNC_AMT | Money | decimal(16,5) | |
CloseMediaUnitQuantity | The closing number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL for a till settlement period which is the time period bounded by two TILL settlement transactions. | QU_CL_MD_UN | QuantityInteger | integer | |
CountedBalanceAmount | The counted tender balance in the TILL for a till settlement period which is the time period bounded by two TILL settlement transactions. The counted balance represents the manually counted amount that is compared to the closing balance to determine over/under variance in tender at the end of a till settlement period. | MO_CNT_BLNC_AMT | Money | decimal(16,5) | |
CountedMediaUnitQuantity | The counted number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL for a till settlement period which is the time period bounded by two TILL settlement transactions. | QU_CNT_MD_UN | QuantityInteger | integer | |
OverUnderBalanceAmount | The variance between closing balance amount and counted balance amount at the end of a till settlement period calculated by subtracting the CountedBalanceAmount from the CloseBalanceAmount A POSITIVE variance means that there is an under variance where the CLOSE balance is higher than the COUNTED balance. A NEGATIVE variance means there is an over variance where the CLOSE balance is less than the COUNTED balance (extra tender) | MO_OVR_UND_BLNC_AMT | Money | decimal(16,5) | |
OverUnderMediaUnitQuantity | The variance between closing media unit quantity and counted media unit quantity at the end of a till settlement period calculated by subtracting the CountedMediaUnitQuantity from the CloseMediaUnitQuantity. A POSITIVE variance means that there is an under variance where the CLOSE media unit quantity is higher than the COUNTED media unit quantity A NEGATIVE variance means there is an over variance where the CLOSE media unit quantity is less than the COUNTED media unit quantity (extra tender) | QU_OVR_UND_MD_UN | QuantityInteger | integer | |
LoanFromSafeAmount | The amount of tender loaded to this TILL from a SAFE during a till settlement period. | MO_LON_FM_SF_AMT | Money | decimal(16,5) | |
LoanFromSafeMediaUnitQuantity | The media unit quantityt of tender loaded to this TILL from a SAFE during a till settlement period. | QU_LON_FRM_SF_MD_UN | QuantityInteger | integer | |
PickupToSafeAmount | The amount of tender picked up from this TILL and moved to a SAFE during a till settlement period. | MO_PKP_TO_SF_AMT | Money | decimal(16,5) | |
PickupToSafeMediaUnitQuantity | The media unit quantity of tender picked up from this TILL and moved to a SAFE during a till settlement period. | QU_PKP_TO_SF_MD_UN | QuantityInteger | integer | |
TipOutAmount | The sum of tip out transaction amounts removed from a till during the till settlement period. | MO_TP_OT_AMT | Money | decimal(16,5) | |
TipOutMediaUnitQuantity | The sum of tip out media unit quantities removed from a till during a till settlement period | QU_TP_OT_MD_UN | QuantityInteger | integer | |
DisbursementAmount | The sum of tender disbursement amounts made from a TILL during a till settlement period. This is generally treated as a petty cash payment by retailers and is used to pay service vendors, charities, etc. from a till. | MO_DSB_AMT | Money | decimal(16,5) | |
DisbursementMediaUnitQuantity | The total media unit quantity paid out of a till as a cash disbursement for a till settlement period. | QU_DSB_MD_UN | QuantityInteger | integer | |
RetailTransactionSettlementAmount | The sum of tender settlement values for retail transactions processed during a till settlement period. Retail transaction settlement represent the receipt or paying out of tender as part of balancing a retail transaction (aka settling the transaction). A negative balance means that a balance is paid out to a customer (as in a refund). A positive balance reflects the normal case where tender (cash, db/cr card, check, coupon, gift certificate,EBT, etc.) is paid in to settle a purchase. | MO_RTL_TRN_STLM_AMT | Money | decimal(16,5) | |
RetailTransactionSettlementMediaUnitQuantity | The sum of retail transaction media unit quantities collected as part of settling retail transactions during a till settlement period. | QU_RTL_TRN_STLM_MD_UN | QuantityInteger | integer | |
FundsReceiptAmount | Sum of NON-RETAIL sale and non-loan related receipt of tender into a till over a till settlement period. | MO_FND_RCPT_AMT | Money | decimal(16,5) | |
FundsReceiptMediaUnitQuantity | Sum of NON-RETAIL sale and non-loan related receipt of tender media unit quantity into a till over a till settlement period. | QU_FND_RCPT_MD_UN | QuantityInteger | integer | |
TenderExchangeAmount | Sum of tender exchanged with other tills during the till settlement period. A negative value indicates a net outflow of tender amount exhanges. A positive value indiates a net inflow of tender amount exchanges. A zero value indicates an even exchange of tender amounts. | MO_TND_EXC_AMT | Money | decimal(16,5) | |
TenderExchangeMediaUnitQuantity | Sum of tender media unit quantities exchanged with other tills during the till settlement period. A negative value indicates a net outflow of tender media unit quantity exhanges. A positive value indiates a net inflow of tender media unit quantity exchanges. A zero value indicates an even exchange of tender media unit quantity. | QU_TND_EXC_MD_UN | QuantityInteger | integer | |
AdjustmentAmount | The sum of tender adjustment amount transactions for a till settlement period. | MO_ADJT_AMT | Money | decimal(16,5) | |
AdjustmentMediaUnitQuantity | The sum of tender adjustment media unit quantity transactions for a till settlement period. | QU_ADJT_MD_UN | QuantityInteger | integer | |